package com.crm.dao;

import java.util.List;
import java.util.Map;

import com.crm.model.ConsultInfoManage;
import com.crm.model.ConsultInfoManagePay;
import com.crm.model.entity.CountWorkBench;
import com.crm.model.entity.KeyValue;

public interface ConsultInfoManageMapper extends BaseMapper<ConsultInfoManage>{
	public List<KeyValue> loadSum(ConsultInfoManage record);

	public List<ConsultInfoManage> selectFinanceGroupBalance(
			ConsultInfoManage manage);

	public ConsultInfoManage getTotalIncome(ConsultInfoManage manage);
	
	public List<CountWorkBench> task(CountWorkBench record);
	
	public CountWorkBench localCount(CountWorkBench record);
	
	public CountWorkBench localGroup(CountWorkBench record);
	
	public CountWorkBench localSum(CountWorkBench record);
	
	public CountWorkBench localSumSort(CountWorkBench record);
	
	public CountWorkBench loadMustPaySum(ConsultInfoManage record);

	public List<ConsultInfoManage> selectFinanceSchoolBalance(
			ConsultInfoManage manage);

	public ConsultInfoManage getSchoolTotalIncome(ConsultInfoManage infomanage);
	
	public ConsultInfoManage getTopOne(ConsultInfoManage record);
	
	public List<ConsultInfoManage> selectFinanceGroupReceivableBalance(
			ConsultInfoManage manage);
			
	public List<ConsultInfoManagePay> getPayByInfoId(String infoManageId);
	
	public ConsultInfoManage getReceivableTotalIncome(ConsultInfoManage t);

	public ConsultInfoManage getSchoolTotalNum(ConsultInfoManage t);

	public ConsultInfoManage loadPersonal(ConsultInfoManage t);

	public List<ConsultInfoManage> selectView(ConsultInfoManage t);
	
	public ConsultInfoManage selectByPrimaryKey2(String infoManageId);

	public List<ConsultInfoManage> selectAllByWhereM(Map<String, Object> map);
	
	public List<ConsultInfoManage> selectRedistributionInfo();

	public List<ConsultInfoManage> selectAllByWhereD(Map<String, Object> map);
}